Solution:
Delete Top (Select Count(*)-1 From employee_test Where employeeid =6)
From employee_test
Where employeeid=6
How to Delete Duplicate Rows retaining only one of them from every set of duplicates - SQL29/1/2013 Solution: Delete Top (Select Count(*)-1 From employee_test Where employeeid =6) From employee_test Where employeeid=6
0 Comments
DECLARE @Parameter1 VARCHAR(MAX) = Null
In the where clause use the format below: WHERE (( @Parameter1 IS NULL) OR ([Field1] = @Parameter1)) --USE CHARINDEX TO GET THE LEFT VALUE FROM STRING (i.e '12345: ABCD EFGH IJK') DECLARE @t1 as varchar (50); SET @t1 = '12345: ABCD EFGH IJK' SELECT LEFT(@t1, CHARINDEX (':' , @t1) -1) EXPECTED RESULT:12345 --USE CHARINDEX TO GET THE RIGHT VALUE FROM STRING (i.e '12345: ABCD EFGH IJK') DECLARE @t2 as varchar (50); SET @t2 = '12345: ABCD EFGH IJK' SELECT RIGHT(@t2, LEN(@t2) - CHARINDEX (':' , @t2) ) EXPECTED RESULT: ABCD EFGH IJK --USE CHARINDEX TO SEPERATE THE LEFT,RIGHT,CENTER, VALUE FROM SINGLE STRING (i.e '12345/ABCD/BULITASKING') DECLARE @t3 as varchar (50); SET @t3 = '12345/ABCD/BULITASKING' SELECT CASE WHEN CHARINDEX('/', @t3) > 0 THEN LTRIM(RTRIM(SUBSTRING(@t3, 1, CHARINDEX('/', @t3)-1))) ELSE @t3 END AS [Column 1] ,CASE WHEN CHARINDEX('/', @t3) > 0 THEN LTRIM(RTRIM(SUBSTRING(RIGHT(@t3, LEN(@t3) - CHARINDEX ('/' , @t3) ), 1, CHARINDEX('/', RIGHT(@t3, LEN(@t3) - CHARINDEX ('/' , @t3) ))-1))) ELSE @t3 END AS [Column 2] ,CASE WHEN CHARINDEX('/', @t3) > 0 THEN RIGHT(RIGHT(@t3, LEN(@t3) - CHARINDEX ('/' , @t3) ), LEN(RIGHT(@t3, LEN(@t3) - CHARINDEX ('/' , @t3) )) - CHARINDEX ('/' , RIGHT(@t3, LEN(@t3) - CHARINDEX ('/' , @t3) ))) ELSE @t3 END AS [Column 3] This stored procedure allows you to observe the progress of a stored procedure or SQL batch.
SELECT [Spid] = session_Id , ecid , [Database] = DB_NAME(sp.dbid) , [User] = nt_username , [Status] = er.status , [Wait] = wait_type , [Individual Query] = SUBSTRING (qt.text, er.statement_start_offset/2, (CASE WHEN er.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE er.statement_end_offset END - er.statement_start_offset)/2) ,[Parent Query] = qt.text , Program = program_name , Hostname , nt_domain , start_time FROM sys.dm_exec_requests er INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid CROSS APPLY sys.dm_exec_sql_text(er.sql_handle)as qt WHERE session_Id > 50 -- Ignore system spids. AND session_Id NOT IN (@@SPID) -- Ignore this current statement. -- AND session_id = 116 ORDER BY 1, 2 Source link: http://www.sqlservercentral.com/articles/DMV/64425/ UPDATE S
SET [Date] = CONVERT(datetime, CAST(Maxdate AS CHAR(8)), 112) , [LoadStatus] = CASE WHEN Maxdate = CAST(CONVERT(char(8), Dateadd(dd,-1,GETDATE()), 112) AS INT) THEN 1 ELSE 0 END FROM rpt.DHWStatus S INNER JOIN ( SELECT B.CompanyKey, max([DateKey]) MaxDate FROM fact.Sales S INNER JOIN dim.Branch B ON S.BranchKey = B.BranchKey WHERE [DateKey] < CAST(CONVERT(char(8), GETDATE (), 112) AS INT) GROUP BY B.CompanyKey ) T ON S.CompanyKey = T.CompanyKey SELECT t.name AS table_name,
SCHEMA_NAME(schema_id)ASschema_name, c.name AS column_name FROMsys.tablesAS t INNERJOINsys.columns c ON t.OBJECT_ID= c.OBJECT_ID WHERE c.name LIKE'%Order%' ORDERBYschema_name, table_name; |
Welcome!Welcome to our edition of eblog! This section will help you find various post and articles that can help you in some of your IT work especially implementing MS BI Solutions. We hope you find this section useful. If you will need further information, please send us your questions and inquiries by going to the "Contact Us" section. Enjoy reading. [Jhon S] Categories
All
|